package com.example.gmallpublisher.mapper;

import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

/**
 * @author w
 * @create 2022-08-02-16:54
 */
public interface SkuOrder {

    @Select ( "select sum(order_amount) from dws_trade_sku_order_window where toYYYYMMDD(stt)=#{date}" )
    BigDecimal selectGmv(int date);
}
